Enhanced grouping and summarizing

Group data hierarchically

Use hierarchical grouping to arrange data in a report to show the hierarchical relationships in your data.

Rename group headers

To better describe a group, use a database field name or Group Name formula to specify the text that appears in the Group Header.

Insert a summary or subtotal on all groups

Choose whether to insert a summary or subtotal on every group, or specify the field you want summarized or subtotaled. You can specify this choice without first selecting a field.

Calculate percentages on grouped data

View the percentage of one group's involvement in a larger group. For example, use the Percentage Summary field to show the percentage of sales in each city of a country based on the total sales of the country.